Returns a Boolean value that indicates whether a query is still executing.
Syntax
object.StillExecuting
The object placeholder represents an object expression that evaluates to an object in the Applies To list.
Return Values
The StillExecuting property return values are:
Value | Description |
True | The query is still executing. |
False | The query is ready to return the result set. |
Remarks
Use the StillExecuting property to determine if a query is ready to return the first result set. Until the StillExecuting property is False, the associated object cannot be accessed. However, unless you use the rdAsyncEnable option, your application will block until the query is completed and ready to process the result set.
Once the StillExecuting property returns False, the first or next result set is ready for processing. When you use the MoreResults method to complete processing of a result set, the StillExecuting property is reset to True while the next result sets is retrieved.
The StillExecuting property also changes to True when you execute a Move method. For example executing MoveLast against an rdoResultset resets the StillExecuting property to True as long as RDO continues to fetch rows from the remote server.
You can also use the QueryComplete event to indicate when a query has completed and the associated rdoResultset object is ready to process.
Use the Cancel method to terminate processing of an executing query, including all statements in a batch query.